﻿CREATE VIEW dbo.V_NSI_PRODUCT_STATE_TYPE
AS
SELECT     ID, NAME, CASE ID WHEN 1 THEN 'Аванс' WHEN 2 THEN 'Аванс' ELSE 'Доплата' END AS TYPE
FROM         dbo.NSI_PRODUCT_STATE